﻿CREATE TABLE [dbo].[t_Dealer] (
    [ID]            INT             IDENTITY (1, 1) NOT NULL,
    [Name]          NVARCHAR (256)  NULL,
    [ShortName]     NVARCHAR (50)   NULL,
    [Street]        NVARCHAR (256)  NULL,
    [City]          NVARCHAR (256)  NULL,
    [State]         CHAR (2)        NOT NULL,
    [Zip]           VARCHAR (10)    NULL,
    [Phone]         VARCHAR (50)    NULL,
    [Fax]           VARCHAR (50)    NOT NULL,
    [EMail]         VARCHAR (128)   NULL,
    [NameSpace]     NVARCHAR (128)  NOT NULL,
    [BranchID]      INT             NULL,
    [Contact]       VARCHAR (50)    NULL,
    [ContactCell]   VARCHAR (50)    NULL,
    [Latitude]      NUMERIC (18, 9) NULL,
    [Longitude]     NUMERIC (18, 9) NULL,
    [BreakdownCode] CHAR (2)        NOT NULL,
    [IsIndependent] BIT             NOT NULL,
    [UsixID]        VARCHAR (4)     NULL,
    [DateCreated]   DATETIME        NOT NULL,
    [DealerCode]    VARCHAR (10)    NULL
);

